<?php
    
   $user  =   $_GET['username'];
   

    mysql_connect("localhost","root","");
    mysql_select_db("trial");
    $search = "SELECT * FROM  `users` WHERE  `username` = '$user'";
    $yes = mysql_query($search);
    while($output = mysql_fetch_assoc($yes));
    if ($output){

        echo "<pre>";
        print_r($output);
        echo "</pre>";
    
    }else {
        echo "couldnt find user";
    }
?>